package com.yunhe.mapper;

import com.yunhe.javabean.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TravellerMapper {
    //根据订单id查询旅客信息
    @Select("select t.* from traveller t,order_traveller ot where t.id=ot.travellerId and ot.orderId=#{oid}")
    public List<Traveller> selectByOid(int oid);
}
